package com.cn.dao;

import java.sql.SQLException;
import java.util.List;

public interface ProviderDAO extends BaseHibernateDAO{
	public List<Object> findByST(int st_id);
	public List<Object> findBySC(int sc_id,int cityID);
	public List listRecommendProviders();
	public List getSCbyPid(int pro_id);
	public  Object findByUsername(String username);
	public Object findById(int id);
	public boolean providerSaveCatalog(int pro_id,int sc_id);
	public List listAllUNAUTHORIZED();
	public List showServicePrice(int pro_id);
	public void providerRank();
	public List<Object> findCollectedProvider(int re_id);
}
